package org.sems.sems.Mapper;

import org.apache.ibatis.annotations.*;
import org.sems.sems.entity.Yqljk;

import java.util.List;

@Mapper
public interface YqljkMapper {
    @Insert("insert into  YQLJK(LJBT, LJDZ, TJR, TJRSFDM) values(#{ljbt}, #{ljdz}, #{tjr}, #{tjrsfdm})")
    int InsertYqljk(Yqljk yqljk);

    @Select("select * from YQLJK")
    List<Yqljk> getALLYqljk();

    @Delete("delete from YQLJK where ID = #{id}")
    int deleteYqljk(int id);

    @Update("update YQLJK set LJBT=#{ljbt},LJDZ=#{ljdz} where ID = #{id}")
    int updateYqljk(Yqljk yqljk);
}
